<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html";>
<meta name="keywords" content="DeZign for Databases - HTML Report">
<meta name="author" content="Datanamic - www.datanamic.com">
<title>DeZign for Databases V4 - HTML Report</title>
<link rel="stylesheet" type="text/css" media="screen,print" href="dezign.css" title="report">
</head>
<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10">
<div class="top">Logical model</div>
<ul id="menu">
<li><a href="index.html">Project details</a></li>
<li><a href="erdiagram.html">ER diagram</a></li>
<li><a href="entl.html">Entities</a></li>
<li><a href="attrl.html">Attributes</a></li>
<li><a href="rell.html">Relationships</a></li>
<li><a href="doml.html">Domains</a></li>
<li><a href="viewl.html">Views</a></li>
<li><a href="procl.html">Procedures</a></li>
</ul>
<div class="row">
<div class="activetab">List of entities</div>
<div class="tab"><a href="entd.html">Entity details</a></div>
</div>
<table width=90% border=0 cellSpacing=0 cellPadding=0 class="chapter">
<tr>
<td class="right" valign=top>
<table width="100%" border=0 class="detailstable">
<tr><td class="fieldname">Entity name</td><td class="fieldname">Primary key attributes</td><td class="fieldname"># Attributes</td><td class="fieldname">Description</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#AdvertizingMethods">AdvertizingMethods</A></td><td class="fielddata">advertizing_method_id</td><td class="fielddata">2</td><td class="fielddata">These are the various advertizing methods considered when performing the advertizing analysis for the sponsor.  A seperate many-to-many table provide the mapping between this table and the sponsors table.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#ApgEmailTemplates">ApgEmailTemplates</A></td><td class="fielddata">template_id</td><td class="fielddata">22</td><td class="fielddata">This is the master repository of all email templates used by sponsors to send promo emails.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#APGs">APGs</A></td><td class="fielddata">apg_id</td><td class="fielddata">13</td><td class="fielddata">This is a master repository of all APGs.  Each APG is defined as a one-to-many mapping of Sponsors to CAPs.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Appointments">Appointments</A></td><td class="fielddata">appointment_id</td><td class="fielddata">12</td><td class="fielddata">The purpose of the meeting.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#ASPs">ASPs</A></td><td class="fielddata">asp_id</td><td class="fielddata">28</td><td class="fielddata">This is the master list of all ASPs doing business with the APG network.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Campaign">Campaign</A></td><td class="fielddata">campaign_id</td><td class="fielddata">17</td><td class="fielddata">This is the master repository of all email campaigns sent out by the system,</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Clicks">Clicks</A></td><td class="fielddata">click_id</td><td class="fielddata">6</td><td class="fielddata">This table is used to track ad statistics, clicks etc.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Contacts">Contacts</A></td><td class="fielddata">contacts_id</td><td class="fielddata">22</td><td class="fielddata">This is the repository of all individuals with which the system interacts.  </td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Coupons">Coupons</A></td><td class="fielddata">coupon_id</td><td class="fielddata">44</td><td class="fielddata">This is a master repository of all eCoupons.  It include all color specification, and references to image and audio files for each coupon.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Deposits">Deposits</A></td><td class="fielddata">deposit_id</td><td class="fielddata">11</td><td class="fielddata">This is the master repository of all deposits related to the APG Network.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Emails">Emails</A></td><td class="fielddata">email_id</td><td class="fielddata">7</td><td class="fielddata">This is a repository of all emails sent out by the system.  This excludes individual promo emails and campaign emails.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#EmailTemplate">EmailTemplate</A></td><td class="fielddata">email_template_id</td><td class="fielddata">7</td><td class="fielddata">This is the set of email template 'specs' edited using the emails screen.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#EventParticipants">EventParticipants</A></td><td class="fielddata">event_id</td><td class="fielddata">7</td><td class="fielddata">Each events has its participants listed in this table.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Events">Events</A></td><td class="fielddata">event_id</td><td class="fielddata">11</td><td class="fielddata">This is the centeral repository of all breakfast and networking events organized to support the APG Network building activities.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Leads">Leads</A></td><td class="fielddata">lead_id</td><td class="fielddata">7</td><td class="fielddata">This is a repository of all leads collected by the system.  This table is populated from uploaded lead files.  As a lead is created, it is linked to a contact in the contacts table.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Locations">Locations</A></td><td class="fielddata">location_id, contacts_id</td><td class="fielddata">11</td><td class="fielddata">This is a master repository of all locations breakfasts and networking meeting.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#MailingLists">MailingLists</A></td><td class="fielddata">mailing_list_id</td><td class="fielddata">2</td><td class="fielddata">This is the master repository of all campaign email lists used by the system.  The content of these lists is typically populated using the APGs.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Markets">Markets</A></td><td class="fielddata">market_id</td><td class="fielddata">3</td><td class="fielddata">The master repository of all markets and their SIC codes.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Packages">Packages</A></td><td class="fielddata">package_id</td><td class="fielddata">5</td><td class="fielddata">A repository of all packages supported by the system.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#RCs">RCs</A></td><td class="fielddata">rc_id</td><td class="fielddata">28</td><td class="fielddata">This is the master list of all ASPs doing business with the APG network.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#RC_Region">RC_Region</A></td><td class="fielddata">rc_id, ZIP_code</td><td class="fielddata">2</td><td class="fielddata">The region associated with an RC is specified using this table.  It is, essentially, a many to many relationship between RCs and ZIP codes.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Redemptions">Redemptions</A></td><td class="fielddata">coupon_instance_id</td><td class="fielddata">6</td><td class="fielddata">This is a master repository of all outstanding and redeemed coupons.  A record is added to this table each and every time a coupon email is sent out.  Coupons can be sent out as part of an email campaign.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Referrals">Referrals</A></td><td class="fielddata">referral_id</td><td class="fielddata">6</td><td class="fielddata">This is a master repository of all referrals.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#SonsorRolodex">SonsorRolodex</A></td><td class="fielddata">sponsor_id, contacts_id</td><td class="fielddata">3</td><td class="fielddata">These are the business associated of the sponsor.  They are populated using the 'business associates' panel in the  APG editor.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Sponsors">Sponsors</A></td><td class="fielddata">sponsor_id</td><td class="fielddata">22</td><td class="fielddata">An indication whether this is an approved Sponsor or Cap. </td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Sponsors_AdvertizingMethods">Sponsors_AdvertizingMethods</A></td><td class="fielddata">sponsor_id, contacts_id, advertizing_method_id</td><td class="fielddata">5</td><td class="fielddata">The monthly cost that the sponsor incurrs for this advertising method.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Sponsors_Markets">Sponsors_Markets</A></td><td class="fielddata">sponsor_id, market_id</td><td class="fielddata">2</td><td class="fielddata"></td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Sponsors_Packages">Sponsors_Packages</A></td><td class="fielddata">sponsor_id, package_id</td><td class="fielddata">2</td><td class="fielddata">These are the packages each sponsor signed up for.  It is a many-to-many mapping between sponsors and packages.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Statements">Statements</A></td><td class="fielddata">statement_id</td><td class="fielddata">6</td><td class="fielddata">This is the master table of all statements available to users.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#SynergesticMarkets">SynergesticMarkets</A></td><td class="fielddata">market_id, syn_market_id</td><td class="fielddata">2</td><td class="fielddata">A list of synergestic markets for each SIC code.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#WebinarParticipants">WebinarParticipants</A></td><td class="fielddata">webinar_id, contacts_id</td><td class="fielddata">6</td><td class="fielddata">The subject webinar.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#Webinars">Webinars</A></td><td class="fielddata">webinar_id</td><td class="fielddata">12</td><td class="fielddata">This is a master repository of all webinar instances.</td></tr>
<tr><td class="fielddata"><A HREF="entd.html#ZIP">ZIP</A></td><td class="fielddata">ZIP_code</td><td class="fielddata">4</td><td class="fielddata">This is a collection of all ZIP codes in the nation.  It is used to associated contacts with cities, counties and states.  and associated RCs with their region.</td></tr>
</table>
</td>
</tr>
</table>
</body>
</html>
